Partition by
Select the function that is used to determine the partition: Hash, Key, Range and List.
Partition no.
Set the partition number.
Subpartition by
Select the function that is used to determine the subpartition: Hash and Key.
Subpartition no.
Set the subpartition number.
Partition Definition
Use Add Partition or Remove Partition to add or delete the partition. Use Add Subpartition or Remove Subpartition to add or delete the subpartition.
Values
For range partitioning, each partition must include a VALUES LESS THAN clause; for list partitioning, you must specify a VALUES IN clause for each partition. This is used to determine which rows are to be stored in this partition.
Engine
Select the storage engine for both partition and subpartition.
Data Directory
The directory where the data for this partition are to be stored.
Index Directory
The directory where the indexes for this partition are to be stored.
Max Rows
The maximum number of rows to be stored in the partition.
Min Rows
The minimum number of rows to be stored in the partition.
Tablespace
Designate a tablespace for the partition. Used for Falcon only.
Nodegroup
Set the Nodegroup.
Comment
Enter the comment for the partition.